| Song | Album | Recording |
|---|---|---|
| String of Pearls, A | Very Best of Glenn Miller, The | 1638 |
| " | Popular Recordings, The (1938-1942) | 4473 |
| " | Swing Era, Music of 1941-1942 | 5283 |
| " | Big Band Jazz | 5483 |
| " | All-Time Greatest Hits of Benny Goodman | 6462 |
SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "String of Pearls, A"